|
Book details / order |
WINDOWS 8 WITH OFFICE 2013 FOR BEGINNERS |
The purpose in writing this book is to help the reader to know enough to get by quickly, cleanly and with a minimum of pain so that he can move on to the more pleasant things in life.
whichever path has led the reader here, he is definitely on the right path!
this book aims serving the beginners as well as the intermediate users. the organization of this book aims to walk the reader through windows 8 and office 2013 in a sequence of increasing complexity.
windows 8 is the newest member of microsoft windows family. it is built for pc as well as tablets.
windows 8 differs from the earlier windows versions. but some features, which were loved in windows 7 are still there in windows 8, in fact has just got better. but in many cases, windows 8 improves them in intuitive and significant ways.
home and business users around the globe turn to microsoft office and its core applications every day. whether you are a newcomer or already familiar with older versions of office, this friendly-but-informative guide provides an in-depth coverage on all the newest updates and enhancements to the office 2013 suite.
roadmap
windows 8 with office 2013 for beginners is divided into six parts.
we start with a section called exploring windows 8 that offers an in-depth knowledge for every windows 8 users, with the help of simple to follow, illustrated step by step guides.
we then set off into a series of chapters [held within section 2: expressing words in office word that covers how to:
write and manage documents
proofread documents
about the authors
vaishali shah [www.vaishalishahonline.com] is a veteran technology author with several for beginners and for professionals titles to her credit. she's written on topics such as java, php, oracle and many more.
minal ghadge, a co-author is a technology aficionado, and a freelance technical writer. she specializes in the use of microsoft office suite. she has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals for over 8 years.
table of contents:
section i: exploring windows 8
1. introduction to windows 8 .............................................................................................. 1
history of windows 8 development................................................................................. 2
developer preview........................................................................................................................... 2
consumer preview ........................................................................................................................... 2
release preview ............................................................................................................................... 2
system requirements .............................................................................................................. 3
windows 8 editions.................................................................................................................... 4
windows 8 pro ................................................................................................................................ 4
windows 8 ....................................................................................................................................... 4
windows 8 enterprise...................................................................................................................... 4
windows rt .................................................................................................................................... 4
windows 8 licenses ................................................................................................................... 4
upgrade license .............................................................................................................................. 4
system builder license ................................................................................................................... 5
oem license ................................................................................................................................... 5
features of windows 8 ............................................................................................................ 5
interface ........................................................................................................................................... 5
start screen .................................................................................................................................. 5
live tiles ..................................................................................................................................... 6
hot corners.................................................................................................................................. 7
charms ............................................................................................................................................. 7
online functionality ........................................................................................................................ 8
sign in with microsoft account.................................................................................................. 8
social networking features ......................................................................................................... 9
other features.................................................................................................................................. 9
simplified desktop for increased speed ..................................................................................... 9
no start button ............................................................................................................................ 9
improved security...................................................................................................................... 10
2. getting to know the user interface - start screen ..................................... 11
logging in to windows 8 ....................................................................................................... 11
exploring the start screen............................................................................................... 14
windows apps............................................................................................................................... 14
windows store............................................................................................................................... 14
microsoft account ......................................................................................................................... 15
tiles ............................................................................................................................................... 15
navigating hot corners ................................................................................................................. 15
lower left ................................................................................................................................. 16
upper left.................................................................................................................................. 16
charms bar .................................................................................................................................... 17
search charm............................................................................................................................. 18
share charm .............................................................................................................................. 20
start charm ................................................................................................................................ 20
devices charm........................................................................................................................... 20
settings charm........................................................................................................................... 21
start screen start menu ................................................................................................................. 22
personalizing the start screen ...................................................................................... 23
viewing personalization pc settings............................................................................................. 23
changing the lock screen............................................................................................................ 25
changing the start screen background ........................................................................................ 26
changing the account picture ...................................................................................................... 27
customizing the start screen apps................................................................................ 28
moving app tiles around ............................................................................................................. 29
removing or unpinning an app tile........................................................................................... 29
pinning an app tile to the start screen ..................................................................................... 30
resizing an app tile .................................................................................................................... 32
uninstalling an app ...................................................................................................................... 33
turning off the live app tile ..................................................................................................... 33
creating app groups ..................................................................................................................... 34
creating a new app group ...................................................................................................... 34
naming the new app group .................................................................................................... 35
privacy of the apps ..................................................................................................................... 37
administrative tools ..................................................................................................................... 40
working with start screen apps ..................................................................................... 41
launching an app from start screen ........................................................................................... 42
closing an app opened from start screen .................................................................................. 42
the people app.............................................................................................................................. 43
exploring the people app......................................................................................................... 44
social feeds ........................................................................................................................... 44
notifications........................................................................................................................... 44
what's new ............................................................................................................................ 45
favourites............................................................................................................................... 45
all contacts ........................................................................................................................... 45
connected networks .............................................................................................................. 45
adding contacts......................................................................................................................... 45
manually adding a new contact.......................................................................................... 45
importing contacts from a service ...................................................................................... 46
viewing contacts ....................................................................................................................... 49
send message......................................................................................................................... 50
video call .............................................................................................................................. 50
call......................................................................................................................................... 51
send email ............................................................................................................................. 51
map address .......................................................................................................................... 51
view profile ........................................................................................................................... 51
table of contents xi
what's new ............................................................................................................................ 51
editing a contact ...................................................................................................................... 51
searching contacts .................................................................................................................... 52
linking contacts........................................................................................................................ 53
adding contacts to your favourites list ................................................................................. 55
pinning contacts to the start screen ....................................................................................... 55
viewing your social feeds ....................................................................................................... 57
changing the profile picture..................................................................................................... 58
the mail app................................................................................................................................. 60
opening the mail app .............................................................................................................. 60
current account..................................................................................................................... 61
folders ................................................................................................................................... 61
current messages................................................................................................................... 61
shortcut buttons .................................................................................................................... 61
message pane......................................................................................................................... 62
how to send emails? ............................................................................................................... 62
reading messages...................................................................................................................... 63
replying to messages ............................................................................................................... 63
organizing mails ....................................................................................................................... 64
moving messages to a folder.............................................................................................. 65
deleting a message ............................................................................................................... 65
adding another account ........................................................................................................... 65
modifying account settings ...................................................................................................... 66
the windows store ....................................................................................................................... 67
navigating the store ................................................................................................................. 68
installing apps ........................................................................................................................... 70
updating apps ........................................................................................................................... 71
shutting down windows 8 ................................................................................................... 72
shutting down ............................................................................................................................... 72
locking the computer .................................................................................................................. 73
signing out .................................................................................................................................... 74
3. getting to know the user interface - desktop ................................................ 75
switching to the desktop.................................................................................................... 75
exploring the desktop mode ............................................................................................. 76
recycle bin.................................................................................................................................... 76
files and folders........................................................................................................................... 76
file explorer .................................................................................................................................. 77
wallpaper....................................................................................................................................... 77
taskbar .......................................................................................................................................... 77
shortcuts on the taskbar ............................................................................................................. 77
date & time and settings............................................................................................................. 77
personalizing the desktop................................................................................................. 77
parts of themes ............................................................................................................................ 78
desktop background.................................................................................................................. 78
sounds........................................................................................................................................ 78
screen saver .............................................................................................................................. 79
opening the personalization dialog box...................................................................................... 79
my themes ................................................................................................................................ 80
windows default themes.......................................................................................................... 80
high contrast themes ............................................................................................................... 80
creating themes ............................................................................................................................ 81
changing the desktop background .......................................................................................... 81
changing the colour of window borders and taskbar.......................................................... 81
changing the sounds ................................................................................................................ 82
changing the screen savers ..................................................................................................... 83
saving a theme ............................................................................................................................ 84
sharing themes ............................................................................................................................. 84
deleting themes ............................................................................................................................ 86
changing the desktop display ......................................................................................... 86
changing the screen resolution................................................................................................... 88
changing the brightness............................................................................................................... 88
changing the display settings for a crt monitor..................................................................... 89
connecting to the second screen ................................................................................................ 89
using cleartype technology ........................................................................................................ 89
working with desktop apps ................................................................................................ 90
launching an app......................................................................................................................... 90
pining an app to the desktop taskbar....................................................................................... 90
customizing the desktop appearance .......................................................................... 92
snap ............................................................................................................................................... 92
peek................................................................................................................................................ 94
shake.............................................................................................................................................. 95
flip ................................................................................................................................................. 95
taskbar......................................................................................................................................... 96
viewing the desktop background ................................................................................................ 96
accessing a jump list .................................................................................................................. 97
locking / unlocking the taskbar ................................................................................................. 97
moving the taskbar ...................................................................................................................... 98
changing the appearance of taskbar buttons ............................................................................ 98
always combine, hide labels ..................................................................................................... 99
combine when taskbar is full................................................................................................... 100
never combine ......................................................................................................................... 100
customizing the notification area ............................................................................................. 100
viewing hidden icons ............................................................................................................. 101
changing the icons and notifications appearance................................................................ 101
show icon and notifications ..................................................................................................... 102
hide icon and notifications ...................................................................................................... 102
only show notifications ........................................................................................................... 102
managing files and folders ............................................................................................ 102
opening the file explorer .......................................................................................................... 102
exploring the file explorer ........................................................................................................ 103
ribbon ..................................................................................................................................... 103
navigation buttons .................................................................................................................. 103
navigation pane ....................................................................................................................... 103
libraries ................................................................................................................................... 104
address bar ............................................................................................................................. 104
search bar................................................................................................................................ 104
file ........................................................................................................................................... 104
changing the content's view ..................................................................................................... 104
sorting files................................................................................................................................. 105
searching for files ...................................................................................................................... 106
opening files with different apps ............................................................................................. 107
changing the default app ...................................................................................................... 109
deleting files ............................................................................................................................... 110
task manager .......................................................................................................................... 111
launching task manager ............................................................................................................ 111
processes.................................................................................................................................. 111
performance ............................................................................................................................. 112
app history ............................................................................................................................. 113
startup...................................................................................................................................... 114
users ........................................................................................................................................ 115
details ...................................................................................................................................... 116
services.................................................................................................................................... 117
control panel ......................................................................................................................... 118
opening control panel................................................................................................................. 119
exploring control panel .............................................................................................................. 120
system and security................................................................................................................. 120
network and internet ............................................................................................................... 120
hardware and sound................................................................................................................ 120
programs .................................................................................................................................. 121
user accounts and family safety............................................................................................ 121
appearance and personalization .............................................................................................. 121
clock, language and region ................................................................................................... 122
ease of access ......................................................................................................................... 122
keeping history of files ............................................................................................................. 122
parental controls.......................................................................................................................... 124
family safety ........................................................................................................................... 126
activity reporting ................................................................................................................... 126
web filtering ........................................................................................................................... 126
time limits ............................................................................................................................. 126
windows store and game restrictions .................................................................................. 126
app restrictions ...................................................................................................................... 127
view activity reports ............................................................................................................. 127
uploading files to skydrive ............................................................................................ 130
accessing skydrive through a web browser ......................................................... 133
opening files ............................................................................................................................... 135
editing files ................................................................................................................................. 135
downloading files ....................................................................................................................... 136
keeping tracks of versions in one place .................................................................................. 137
installing skydrive desktop app .................................................................................. 138
5. user accounts ....................................................................................................................... 145
adding new users................................................................................................................... 145
adding a new local user ................................................................................................... 150
changing user account type .......................................................................................... 152
6. security and maintenance............................................................................................ 157
security features of windows 8 .................................................................................... 157
user account control .................................................................................................................. 158
windows defender ...................................................................................................................... 158
windows smartscreen ................................................................................................................. 158
windows firewall ........................................................................................................................ 158
action center .......................................................................................................................... 158
troubleshoot.......................................................................................................................... 161
programs ...................................................................................................................................... 162
hardware and sound................................................................................................................... 162
network and internet .................................................................................................................. 162
system and security.................................................................................................................... 163
recovery........................................................................................................................................ 163
7. introduction to windows 8.1 ....................................................................................... 165
how to get the windows 8.1 preview? .......................................................................... 166
features of windows 8.1 preview................................................................................... 166
personalizing lock screen........................................................................................................... 166
personalizing start screen ........................................................................................................... 167
start screen viewing ................................................................................................................... 167
viewing multiple apps without snap view ............................................................................... 168
search........................................................................................................................................... 168
skydrive ...................................................................................................................................... 169
pc settings................................................................................................................................... 169
internet explorer version 11........................................................................................................ 169
windows store revamped ........................................................................................................... 170
mail app ...................................................................................................................................... 170
photo app .................................................................................................................................... 170
conclusion................................................................................................................................ 170
section ii: expressing words in office word
8. introduction to office word 2013 ............................................................................ 171
starting office word 2013 ................................................................................................. 172
exploring word 2013 ............................................................................................................. 173
quick access toolbar.................................................................................................................. 173
title bar ....................................................................................................................................... 174
file tab ........................................................................................................................................ 174
minimize, maximize and close buttons...................................................................................... 174
ribbon ......................................................................................................................................... 174
home tab ................................................................................................................................ 174
insert tab ................................................................................................................................. 175
page layout tab ...................................................................................................................... 176
references tab ........................................................................................................................ 177
mailings tab ............................................................................................................................ 177
review tab .............................................................................................................................. 178
view tab ................................................................................................................................. 179
add-ins tab ............................................................................................................................. 179
design tab ............................................................................................................................... 179
dialog box launcher................................................................................................................... 180
status bar..................................................................................................................................... 180
zoom control............................................................................................................................... 180
page views .................................................................................................................................. 180
mini toolbar ................................................................................................................................ 181
live preview ................................................................................................................................ 181
contextual tab............................................................................................................................. 181
key tips ...................................................................................................................................... 182
screen tips .................................................................................................................................. 182
creating a word document ............................................................................................. 183
creating a blank word document............................................................................................... 183
creating a word document based on a template.................................................................... 184
opening an existing document ....................................................................................... 186
saving a document ............................................................................................................... 187
closing a document ............................................................................................................. 188
9. managing document.......................................................................................................... 191
page margins............................................................................................................................ 191
page size...................................................................................................................................... 194
page orientation ................................................................................................................... 194
adding text............................................................................................................................... 195
cutting, copying and pasting text .............................................................................. 195
finding and replacing text ............................................................................................. 197
creating bulleted and numbered list ...................................................................... 198
working with fonts ............................................................................................................. 200
changing font style .................................................................................................................... 200
applying bold, italics and underline ......................................................................................... 202
applying strikethrough, subscript and superscript.................................................................... 203
changing font color.................................................................................................................... 204
using format painter ................................................................................................................... 205
paragraph formatting ...................................................................................................... 206
indenting paragraph ..................................................................................................................... 206
bordering paragraph .................................................................................................................... 207
page background .................................................................................................................. 208
watermarks ............................................................................................................................. 210
adding built-in watermark ......................................................................................................... 210
creating and applying custom watermark................................................................................ 212
page borders ............................................................................................................................ 213
header and footer................................................................................................................ 214
document view........................................................................................................................ 216
printing a document ............................................................................................................ 218
10. proofreading documents ............................................................................................ 221
spelling and grammar ....................................................................................................... 221
thesaurus .................................................................................................................................. 223
counting number of words.............................................................................................. 224
autocorrect ............................................................................................................................ 225
restricting editing a document.................................................................................... 228
comments................................................................................................................................... 230
track changes ........................................................................................................................ 231
reviewing a document with track changes ............................................................................. 232
accepting and rejecting track changes .................................................................................... 232
11. working with pictures ................................................................................................. 235
picture......................................................................................................................................... 235
smartart.................................................................................................................................... 236
shape............................................................................................................................................. 238
wordart ..................................................................................................................................... 239
working with picture.......................................................................................................... 240
cropping a picture ...................................................................................................................... 240
adding a border to a picture .................................................................................................... 241
removing the background of a picture .................................................................................... 241
changing the brightness or contrast of a picture .................................................................... 242
setting height and width of a picture ...................................................................................... 243
grouping objects ......................................................................................................................... 243
wrapping text.......................................................................................................................... 244
12. working with tables ...................................................................................................... 245
inserting a table ................................................................................................................... 246
adding rows and columns to an existing table .................................................. 247
setting row height and column width...................................................................... 249
merging and splitting cells ........................................................................................... 249
splitting a table .................................................................................................................... 251
setting cell margins and spacing................................................................................ 252
inserting a formula ............................................................................................................ 252
adding borders and shadings ........................................................................................ 253
13. mail merge, envelopes and labels ........................................................................ 255
mail merge ................................................................................................................................ 255
setting the environment for mail merge................................................................................... 255
adding and editing recipients ................................................................................................... 257
adding new recipient address list ....................................................................................... 257
selecting the existing recipient address list........................................................................ 259
edit recipient address list ..................................................................................................... 260
inserting mail merge fields......................................................................................................... 262
previewing mail merge ............................................................................................................... 264
completing mail merge............................................................................................................... 265
creating envelopes.............................................................................................................. 266
creating labels ..................................................................................................................... 271
section iii: working with numbers in office excel
14. introduction to office excel 2013 ......................................................................... 275
getting started with office excel 2013 ..................................................................... 276
starting office excel 2013........................................................................................................... 277
exploring excel 2013 ............................................................................................................ 278
quick access toolbar.................................................................................................................. 278
title bar ....................................................................................................................................... 278
file tab ........................................................................................................................................ 279
minimize, maximize and close buttons...................................................................................... 279
ribbon ......................................................................................................................................... 279
home tab ................................................................................................................................ 279
insert tab ................................................................................................................................. 280
page layout tab ...................................................................................................................... 281
formulas tab ........................................................................................................................... 281
data tab................................................................................................................................... 282
review tab .............................................................................................................................. 283
view tab ................................................................................................................................. 283
formula bar ................................................................................................................................. 284
name box .................................................................................................................................... 284
status bar..................................................................................................................................... 284
worksheet .................................................................................................................................... 284
scroll bars ................................................................................................................................... 285
creating a workbook ......................................................................................................... 285
creating a blank workbook ........................................................................................................ 285
creating a workbook based on a template ............................................................................. 286
opening an existing workbook ...................................................................................... 286
saving a workbook .............................................................................................................. 287
closing a workbook ............................................................................................................ 289
15. managing worksheets and cells ........................................................................... 291
what is a workbook? ........................................................................................................... 291
what is a worksheet? .......................................................................................................... 291
data .............................................................................................................................................. 292
adding a new worksheet ................................................................................................... 292
renaming a worksheet ....................................................................................................... 293
deleting a worksheet......................................................................................................... 295
inserting rows and columns .......................................................................................... 296
deleting rows and columns ............................................................................................ 297
adding data to a worksheet ........................................................................................... 298
cutting, copying and pasting data.............................................................................. 299
setting the row height....................................................................................................... 300
setting the column width ................................................................................................ 301
managing the appearance of data .............................................................................. 302
aligning cell data ............................................................................................................... 304
wrapping data in a cell ..................................................................................................... 305
merging cells .......................................................................................................................... 306
setting orientation of cell data................................................................................. 307
adding borders to cells.................................................................................................... 308
using format painter .......................................................................................................... 309
header and footer................................................................................................................ 310
setting worksheet margins ............................................................................................ 312
printing a worksheet .......................................................................................................... 313
16. conditional formatting, sorting and filtering data ............................ 317
conditional formatting ................................................................................................... 317
highlight cells rules ................................................................................................................... 318
top/bottom rules ........................................................................................................................ 320
data bars...................................................................................................................................... 322
color scales ................................................................................................................................. 323
icon sets....................................................................................................................................... 324
creating new conditional formatting rules............................................................................... 326
sorting data ............................................................................................................................ 329
filtering data ......................................................................................................................... 331
17. charts, smartart graphics and sparklines .................................................... 335
charts.......................................................................................................................................... 335
types of charts ........................................................................................................................... 335
column chart........................................................................................................................... 336
bar chart.................................................................................................................................. 336
line chart ................................................................................................................................ 337
pie chart .................................................................................................................................. 337
area chart................................................................................................................................ 338
surface chart ........................................................................................................................... 339
radar chart .............................................................................................................................. 339
doughnut chart ....................................................................................................................... 340
xy (scatter) chart ................................................................................................................... 340
bubble chart ............................................................................................................................ 341
stock chart .............................................................................................................................. 342
creating a chart .......................................................................................................................... 342
converting a chart type into another type .............................................................................. 343
printing a chart........................................................................................................................... 344
setting a chart title .................................................................................................................... 345
setting the axis title .................................................................................................................. 346
setting the legend ...................................................................................................................... 346
smartart graphics ............................................................................................................... 348
inserting smartart graphics ........................................................................................................ 348
adding text ................................................................................................................................. 350
adding a style ............................................................................................................................ 350
sparklines ................................................................................................................................. 352
creating sparklines...................................................................................................................... 352
changing the type and color of sparklines............................................................................. 353
highlighting data points ............................................................................................................. 355
18. formulas and functions .............................................................................................. 357
formulas ................................................................................................................................... 357
operators...................................................................................................................................... 358
arithmetic operators ............................................................................................................... 358
comparison operators ............................................................................................................. 358
text concatenation operator ................................................................................................... 359
reference operator .................................................................................................................. 359
operator precedence .................................................................................................................... 359
cell referencing .......................................................................................................................... 359
absolute cell references......................................................................................................... 360
relative cell references.......................................................................................................... 360
mixed cell references............................................................................................................. 360
functions ................................................................................................................................... 360
function syntax ........................................................................................................................... 361
correcting errors ......................................................................................................................... 361
product function.................................................................................................................... 361
sum function ............................................................................................................................. 362
average function ................................................................................................................... 363
concatenate function......................................................................................................... 364
find function ............................................................................................................................. 365
and function...............................................................................................................
Author : Minal ghadge, vaishali shah
Publication : Spd
Isbn : 9789351102502
Store book number : 105
NRS 640.00
|
|
|
|
|
|
|
|
|
|